package cn.clwxy.gdz.service;

import java.util.List;

import org.apache.commons.dbutils.handlers.BeanListHandler;

import cn.clwxy.gdz.bo.StudentInfoPageOrderListBean;

import cn.clwxy.gdz.util.BaseDao;

public class StudentInfoPageOrderListBeanDaoImpl extends BaseDao implements StudentInfoPageOrderListBeanDao{

	@Override
	public List<StudentInfoPageOrderListBean> getStudentInfoPageOrderListBeanByStudentId(
			Integer studentId) {
		String sql="SELECT o.orderId,t.teacherRealName,o.profit,o.orderFinishTime,studentId FROM `order` o INNER JOIN teacher t ON t.teacherId=o.teacherId where studentId=?";
		return super.queryList(sql,new BeanListHandler<StudentInfoPageOrderListBean>(StudentInfoPageOrderListBean.class), studentId);
	}

}
